﻿if exists (select * from dbo.sysobjects where name = 'sp_tblUser_Update')
	drop procedure [dbo].[sp_tblUser_Update]
Go 
CREATE PROCEDURE dbo.sp_tblUser_Update
@_uid	int,
@_uname	nvarchar(256),
@_uaccount	nvarchar(256),
@_upassword	nvarchar(256),
@_ustatus	smallint,
@_ucreatedate	datetime
AS
UPDATE tblUser SET [_uname] = @_uname,[_uaccount] = @_uaccount,[_upassword] = @_upassword,[_ustatus] = @_ustatus,[_ucreatedate] = @_ucreatedate
WHERE  _uid= @_uid
Go